Business / Compliance and Risk / Foundation

Advanced Excel Formulas & Functions

Data analysis, Excel, Formulas

Write powerful dynamic formulasExplore case studiesAnalyze dates, text fields, values and arrays

Course Duration : 2-6 hours Content Providers : Data Driven

Course content

Lesson Excel Lesson type: Event
- Excel
- Excel Formulas 101
  - The Forumla Library and Auditing Tools
  - Fixed, Relative and Mixed References
  - Common Errors and the IFERROR statement
  - Function, CTRL & ALT Shortcuts
  - Creating Custom Data Validation Rules
- Assessment